FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread.CellType 名前空間 > DateTimeCellType クラス > SetCalendarText メソッド : SetCalendarText(String[],String[],String[],String[],String,String) メソッド |
'Declaration Public Overloads Sub SetCalendarText( _ ByVal dayNames() As String, _ ByVal monthNames() As String, _ ByVal shortdayNames() As String, _ ByVal shortmonthNames() As String, _ ByVal okText As String, _ ByVal cancelText As String _ )
'使用法 Dim instance As DateTimeCellType Dim dayNames() As String Dim monthNames() As String Dim shortdayNames() As String Dim shortmonthNames() As String Dim okText As String Dim cancelText As String instance.SetCalendarText(dayNames, monthNames, shortdayNames, shortmonthNames, okText, cancelText)
public void SetCalendarText( string[] dayNames, string[] monthNames, string[] shortdayNames, string[] shortmonthNames, string okText, string cancelText )
名前を表す4つの文字列配列は、DateTimeCellTypeエディタで使用されるddd、dddd、MMM、MMMMの各形式の名前を設定します。これらの文字列配列にnullを指定した場合、その名前についてはDateTimeCellTypeのプロパティに設定された値が使用されます。それらがnullの場合は、システム名が使用されます。
2つのテキストパラメーターにより、カレンダーコントロールの下部に表示されるボタンのテキストが決まります。
このメソッドは個々のセルのみにカレンダーテキストを設定します。したがって、同じSPREAD内の異なるセルに異なるカレンダーテキストを設定することが可能です。
月名を含む1次元の文字列配列の詳細については、Microsoft .NET FrameworkドキュメントのMonthNamesを参照してください。
Dim dt As New FarPoint.Win.Spread.CellType.DateTimeCellType() Dim dNames() As String = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"} Dim mNames() As String = {"Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec",""} Dim sdNames() As String = {"SU", "M", "T", "W", "TH", "F", "S"} Dim smNames() As String = {"J", "F", "M", "A", "MY", "J", "JY", "AG", "S", "O", "N", "D",""} Dim okbutn As String = "Accept" Dim canbutn As String = "Decline" dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined dt.UserDefinedFormat = "dddd MMMM d, yyyy" dt.SetCalendarText(dNames(),mNames(),sdNames(),smNames(),okbutn, canbutn) FpSpread1.ActiveSheet.Cells(0, 0).CellType = dt FpSpread1.ActiveSheet.Cells(0, 0).Value = Now FpSpread1.ActiveSheet.Columns(0).Width = 130
FarPoint.Win.Spread.CellType.DateTimeCellType dt = new FarPoint.Win.Spread.CellType.DateTimeCellType(); string[] dNames = {"Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"}; string[] mNames = {"Jan", "Feb", "Mar", "Apr", "May", "June", "July", "Aug", "Sep", "Oct", "Nov", "Dec",""}; string[] sdNames = {"SU", "M", "T", "W", "TH", "F", "S"}; string[] smNames = {"J", "F", "M", "A", "MY", "J", "JY", "AG", "S", "O", "N", "D",""}; string okbutn = "Accept"; string canbutn = "Decline"; dt.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.UserDefined; dt.UserDefinedFormat = "dddd MMMM d, yyyy"; dt.SetCalendarText(dNames,mNames,sdNames,smNames,okbutn, canbutn); fpSpread1.ActiveSheet.Cells[0, 0].CellType = dt; fpSpread1.ActiveSheet.Cells[0, 0].Value = System.DateTime.Now; fpSpread1.ActiveSheet.Columns[0].Width = 130;